-- 실행계획 수집 
SQL> EXPLAIN PLAN FOR
     SELECT *
     FROM EMP E
     WHERE E.EMPNO = 9999999
       AND E.DEPTNO = 10;

-- ADVANCED Format 으로 조회하면 아래와 같은 정보를 조회 할 수 있다. 
SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY(NULL, NULL, 'ADVANCED'));

-- PLAN 정보
--------------------------------------------------------------------------------------
| Id  | Operation                   | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |        |     1 |    18 |     3   (0)| 00:00:01 |
|*  1 |  TABLE ACCESS BY INDEX ROWID| EMP    |     1 |    18 |     3   (0)| 00:00:01 |
|*  2 |   INDEX UNIQUE SCAN         | EMP_U1 |     1 |       |     2   (0)| 00:00:01 |
--------------------------------------------------------------------------------------

-- Outline Data 정보
Outline Data
-------------
/*+
    BEGIN_OUTLINE_DATA
    INDEX_RS_ASC(@"SEL$1" "E"@"SEL$1" ("EMP"."EMPNO"))
    OUTLINE_LEAF(@"SEL$1")
    ALL_ROWS
    OPT_PARAM('_optim_peek_user_binds' 'false')
    OPT_PARAM('_fast_full_scan_enabled' 'false')
    OPT_PARAM('_b_tree_bitmap_plans' 'false')
    OPTIMIZER_FEATURES_ENABLE('10.2.0.3')
    IGNORE_OPTIM_EMBEDDED_HINTS
    END_OUTLINE_DATA
*/

-- Query Block Name 정보
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1 / E@SEL$1
2 - SEL$1 / E@SEL$1

-- Predicate Information 정보
Predicate Information (identified by operation id):
---------------------------------------------------
   1 - filter("E"."DEPTNO"=10)                                                        
   2 - access("E"."EMPNO"=9999999)

-- Column Projection Information 정보
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "E"."EMPNO"[NUMBER,22], "E"."JOB"[VARCHAR2,3], "E"."HIREDATE"[DATE,7],
"E"."DEPTNO"[NUMBER,22]
2 - "E".ROWID[ROWID,10], "E"."EMPNO"[NUMBER,22]